My Stuff
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
-
Re: Work order completion with backflush after inventory issue generates error
Hi @moonking, It seems that the item you used in your example is a Serialized Assembly item. The serial number per item should be unique, so the quantity column is greyed out and defaulted to 1. I di…1 -
Re: Item Receipt vs. PO Line Data Formula (Inventory Detail Status)
Hi @jmack_admin, Please try this formula using a Formula (Numeric) field with Summary Type = Maximum: MAX{appliedtotransaction.quantity} - SUM(CASE WHEN {inventorydetail.status} = 'Bad' THE…1 -
Re: Work order completion with backflush after inventory issue generates error
Hi @moonking, I did further tests on the scenario that you provided and I noted that once you issue the components, it does not show in the Committed column, but shows in the Used In Build column ins…1 -
Re: Inventory Counts Review
Hi there @Brad3987399, I checked my resources on this and found that it is not yet possible to export the Inventory Worksheet table data. There is an enhancement logged requesting for this ability: E…2 -
Re: Save search with calculating inventory aging formula question
Hi @Angel Chang, Here's my understanding of the logic that you mentioned: CASE WHEN {Ending Quantity} > {Less than 3 Months Inputs} THEN {Les than 3 Months Inputs} ELSE {Ending Quantity} END …1
